package com.fowo.api.model.quality.check.storage;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import javax.validation.constraints.*;
import lombok.Data;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.fowo.api.sys.entity.SysFile;
import com.fowo.api.common.excel.ImageConvert;
import java.util.List;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.fowo.api.common.validator.EnumsString;

/** 质检单 导入导出辅助模型 */
@Data
public class QualityCheckStorageExcelPo {
@Size(max = 50, message = "质检单号长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "质检单号")
    private String qcSn;

@Size(max = 500, message = "图片长度不能超过20")
    @ExcelProperty(value = "图片",converter = ImageConvert.class)
    private List<SysFile> productImg;

@Size(max = 50, message = "品名长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "品名")
    private String productNameName;

@ExcelIgnore
    @ExcelProperty(value = "品名")
    private Long productName;

@Size(max = 50, message = "SKU长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "SKU")
    private String sku;

@Size(max = 50, message = "商品标签长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "商品标签")
    private String productLabel;

@Size(max = 50, message = "店铺长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "店铺")
    private String shopShopName;

@ExcelIgnore
    @ExcelProperty(value = "店铺")
    private Long shop;

@Size(max = 50, message = "FNSKU长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "FNSKU")
    private String fnsku;

@Size(max = 50, message = "采购单号长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "采购单号")
    private String purchaseCodePurchaseOrderCode;

@ExcelIgnore
    @ExcelProperty(value = "采购单号")
    private Long purchaseCode;

@Size(max = 50, message = "采购员长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "采购员")
    private String buyerNameName;

@ExcelIgnore
    @ExcelProperty(value = "采购员")
    private Long buyerName;

@Size(max = 50, message = "收货人长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "收货人")
    private String receiveNameName;

@ExcelIgnore
    @ExcelProperty(value = "收货人")
    private Long receiveName;

@Size(max = 50, message = "仓库长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "仓库")
    private String warehouseName;

@ExcelIgnore
    @ExcelProperty(value = "仓库")
    private Long warehouse;

@Size(max = 50, message = "供应商长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "供应商")
    private String supplierSupplierName;

@ExcelIgnore
    @ExcelProperty(value = "供应商")
    private Long supplier;

@DateTimeFormat("yyyy年MM月dd日HH:mm:ss")
    @ExcelProperty(value = "到货时间")
    private java.util.Date receiveTime;

@Size(max = 50, message = "收货单号长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "收货单号")
    private String deliveryOrderSn;

    @ExcelProperty(value = "质检量")
    private Long productReceiveNum;

@EnumsString(value = {"抽检", "全检"}, message = "质检方式的可用值为 “抽检”, “全检” 其中之一")
@Size(max = 50, message = "质检方式长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "质检方式")
    private String qcMethodType;

    @ExcelProperty(value = "抽检合格率")
    private java.math.BigDecimal qcRatePass;

    @ExcelProperty(value = "良品量")
    private Integer productGoodNum;

    @ExcelProperty(value = "次品量")
    private Integer productBadNum;

@Size(max = 50, message = "质检员长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "质检员")
    private String qcNameName;

@ExcelIgnore
    @ExcelProperty(value = "质检员")
    private Long qcName;

@DateTimeFormat("yyyy年MM月dd日HH:mm:ss")
    @ExcelProperty(value = "质检时间")
    private java.util.Date qcTime;

@Size(max = 50, message = "备注长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "备注")
    private String remark;

@EnumsString(value = {"质检中", "待审批", "已完成", "已撤销", "以免检"}, message = "质检状态的可用值为 “质检中”, “待审批”, “已完成”, “已撤销”, “以免检” 其中之一")
@Size(max = 50, message = "质检状态长度不能超过20")
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.LEFT, dataFormat = 49)
    @ExcelProperty(value = "质检状态")
    private String qcStatus;

}
